Topic: Understanding Trade of Different Commodities in the following countries:

Presented by: Team Nemo

Prachi Jaiswal

Yuwei Jiang

Sithalakshmi Jawahar

Introduction

Data Source

Data cleaning

Introduction

Given the recent Suez Canal fiasco, many countries were facing severe problems in trade markets. Which made us all curious to dive deeper into the subject.

For our analysis we will compare the export and import patterns over a span of 3 years. And according to World Statistical Review 2019, the countries that we have chosen are taken as the top three global trading economies.

For our analysis we are comparing the export and import patterns of these countries over a span of three years to see if they have an import or export deficit, if so, which sector is causing the same. Sectors where they have good in- house production and where they need the materials from other countries.

Data Source

This report contains data taken from the UN Data Bank (http://data.un.org/Explorer.aspx). To answer our questions, we have selected the following factors to filter out a suitable data-set:

• Database: Trade (Import and Export)

• Countries: Germany, China, USA.

• Time frame: 2016 to 2018.

Data Cleaning

Data Cleaning Output

Traded goods over from 2016 to 2018

Key Points:

• Germany is an Export Dominant Economy.

• Germany is the most powerful economy of Europe with biggest export commodities as automobiles and medicaments.

• Export is one of the vital factors that increase the foreign exchange reserves held in the nation’s central bank.

• When traders pay for exports either in their own currency or the U.S. dollars, and they are kept in the foriegn exchange reserves

• Foreign exchange reserves are cash and other reserve assets such as gold held by a central bank or other monetary authority

• Country’s Foreign exchange reserves are directly proportional to Country’s own currency value.

• Consequently lowes the cost of their exports

Import Trades of China

Export Trades of China

Analysis

China is an Export Dominant Economy.

When we compare the total trades between import and export trades of China, we could draw some conclusions:

1. Though the import trades of cars are higher than export trades these years, there is a good upward momentum in the tendency of export trades of cars. It might be predicted that the export trades of cars will be more than import cars trades sooner or later.

2. Though the trades of iron_steel win a place in the top4 both in import and export trades of China, the amount of export trades of iron_steel are much larger than that of import trades. That is imports are less than half of exports.

3. The status of imported pharma trades are higher than that of export trades. And from 2016 to 2018 the amount of imports is getting higher year after year. This might imply that China has a certain degree of dependence on the global import trade of medical and devices.

Trade War

Fun Facts

• USA is an Import Dominant Economy.

• Middle-Class Americans gain more than a quarter of their purchasing power from trade

• In 2018, Exports of Goods and Services made up about 12.22% of their GDP

• USA has the largest GDP in the world of 19.07 trillion

• One of Joe Biden’s earliest commitments’ was that saying his administration would review the trade war and other actions taken against China. In remedy to the trade war started by his predecessor

It all started with the Barter System

Conclusion

• Three largest trading economies: two export and one import

• Cars, Iron and Steel and Pharmaceuticals are major contributors in the flux in all three countries

• From Barter to Bitcoin, growth involved wars, billion dollar debts, outcries and high stake consequences when one ship got stuck in the Suez Canal

Under the Guidance of:

Patricia Menéndez Galvan

Fan Cheng